Database Management

As a Lead IMS z O/S - Card Platform Services Team, you are an integral part of an agile team that works to enhance, build, and deliver database requirements by ensuring data is available, accessible, reliable, and recoverable. You will administer, design, implement, and support highly available and scalable Mainframe DB2 & IMS database solutions, manage data models, resolve performance issues, and provide 24/7 on-call support for critical database environments. This role involves maintaining architectures across multiple technical areas to support business objectives.

Must Have

• Administer, design, implement, and support Mainframe DB2 & IMS database solutions.
• Implement data models, database designs, data access, and table maintenance codes.
• Maintain DB2/IMS Databases with High Availability using Data Partitioning and replications.
• Resolve database performance, capacity, replication, and other data issues.
• Collaborate with Information Architects and Database Designers for physical data model implementation.
• Develop database performance monitoring processes and analyze data for optimization opportunities.
• Provide Level 2 on-call support for 24/7 DB2/IMS database environment.
• Manage on-site backup and recovery processes.
• Plan for and execute required database upgrades or migrations.
• Work with database admin tools like CA Platinum, BMC, IBM Admin tools, Mainview, IBM Data Studio, BMC Recovery management.
• Formal training or certification on software engineering concepts.
• Experience in database design/development, integration, performance monitoring and tuning, systems re-engineering and Operations support.
• Knowledge of DB2 for z/OS along with mainframe related tools such as BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF.
• Expertise with IMS Full Function/Fast Path database implementation, REXX programming and MQ.
• Experience in IBM Replication CDC, QREP.
• Experience with Atlassian tools like Jira, Confluence.
• Proven background on database engineering, automation, monitoring, performance engineering design and implementations.
• Knowledge of industry-wide technology trends and best practices.

Good to Have

• Experience providing 24x7 rotational support
• Understanding of Distributed and Static SQL workloads
• Familiar with IDAA (Data Analytics Accelerators)

Perks & Benefits

• Medical/dental/vision insurance
• HSA
• FSA
• 401(k)
• Life, disability & ADD insurance
• Paid time off (for salaried personnel)
• Paid sick leave (for hourly employees on a Service Contract Act project)

Overview: As a Lead IMS z O/S - Card Platform Services Team, you are an integral part of an agile team that works to enhance, build, and deliver database requirements to meet product business deliverables by ensuring the data is always available, accessible, reliable and recoverable. As a core technical contributor, you are responsible for maintaining the critical database and architectures across multiple technical areas within various business functions in support of the firm's business objectives.

Responsibilities:

• Administer, design, implement and support highly available and scalable Mainframe DB2 & IMS database solutions
• Implement data models, database designs, data access and table maintenance codes
• Implement and maintaining the DB2/IMS Databases with High Availability features using Data Partitioning and Database replications
• Resolve database performance issues, database capacity issues, replication and other data issues
• Work with Information Architects and Database Designers to implement the physical data model
• Develop the database performance monitoring process and analyze data for optimization opportunities
• Provide up to Level 2 on call support for the 24/7 DB2/IMS database environment
• Manage on-site backup and recovery process
• Plan for and execute required database upgrades or migrations
• Work with database admin tools like CA Platinum/ BMC/ IBM Admin tools, Mainview, IBM Data Studio, BMC Recovery management, etc.

Requirements

• Formal training or certification on software engineering concepts and 5+ years applied experience
• Database design/development, integration, performance monitoring and tuning, systems re-engineering and Operations support
• Knowledge of DB2 for z/OS along with mainframe related tools such as BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF
• Expertise with IMS Full Function/Fast Path database implementation, REXX programming and MQ
• Experience in IBM Replication CDC, QREP
• Capable of creating the roadmap, processes, best practices, standards, and strategies for continuous improvement, resiliency, and scalability
• Experience with Atlassian tools like Jira, Confluence
• Proven background on database engineering, automation, monitoring, performance engineering design and implementations
• Strong execution mind-set to manage and track progress against transformation goals
• Knowledge of industry-wide technology trends and best practices

Preferred Qualifications:

• Experience providing 24x7 rotational support
• Understanding of Distributed and Static SQL workloads
• Familiar with IDAA (Data Analytics Accelerators)